SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.001634
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using index condition |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: moods
Run Time: 0.000421
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using index condition |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 9ff80dd1a2a868c4a1db4086dba0f0bf, 1716190302
Run Time: 0.000506
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000376
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.001848
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 120 | Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.001664
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 124 | Using index condition |
SELECT thread.*
,
NULL AS thread_read_date,
node.node_id AS forum_id, node.title AS forum_title,
user.*
FROM xf_thread AS thread
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
INNER JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (1=1) AND (thread.node_id IN (186, 42, 75, 382, 9, 10, 12, 13, 14, 286, 50, 51, 199, 91, 117, 243, 242, 281, 381, 375, 153, 282, 370, 371, 376, 377, 378, 379, 380, 56, 384, 385, 324, 4, 15, 76, 263, 227, 228, 229, 230, 46, 357, 89, 18, 21, 239, 25, 148, 152, 17, 169, 28, 147, 72, 73, 23, 94, 32, 41, 194, 195, 196, 208, 133, 101, 123, 30, 74, 237, 280, 29, 40, 78, 22, 43, 37, 45, 86, 70, 126, 128, 19, 177, 48, 146, 181, 182, 20, 24, 183, 330, 170, 176, 223, 224, 226, 187, 225, 291, 288, 171, 172, 175, 173, 284, 193, 53, 155, 99, 100, 93)) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated'))
ORDER BY thread.post_date DESC
LIMIT 10
Run Time: 0.003267
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | index | node_id_last_post_date,node_id_sticky_state_last_post | post_date | 4 | | 11 | Using where; Backward index scan |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | xf.thread.node_id | 1 | Using index |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | xf.thread.node_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.thread.user_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 72
Run Time: 0.000310
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 173
Run Time: 0.000241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 20
Run Time: 0.000236
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 18
Run Time: 0.000251
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
UPDATE `xf_session` SET `expiry_date` = ?, `session_data` = ? WHERE (session_id = '9ff80dd1a2a868c4a1db4086dba0f0bf')
Params: 1716193902,
Run Time: 0.004671
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , VietXfAdvStats_ControllerPublic_AdvStats, ThreadsLatest, valid, , 1716190302,
Run Time: 0.004613
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'BRQCT_forum_list_nodes', 'BRQCT_ad_sidebar_top', 'BRQCT_navigation_tabs_forums', 'stylium_setting_value', 'stylium_page_container_head', 'stylium_settings', 'stylium_setting_toggle_footer', 'VietxfAdvStats_threads_latest', 'VietXfAdvStats_threads', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000814
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 11 | Using index condition |